Reproducible data collection

Plant Functional Trait Courses

Design spreadsheets

Spreadsheet content

Design spreadsheet - paper

Design spreadsheet - digital

Design spreadsheet - data validation

Design spreadsheet - data validation

Digitizing spreadsheets

Tidy data

Long or wide format

Consistency in datasheets

Consistency - meaningful names

Consistency - meaningful names

• T

• bird_raw

• jja1b

• mean

• data

• ddd

Consistency - meaningful names

• A name can contain letters, numbers, dot and underscore

• First letter must be letter or dot. If the first character in a name is a dot, the object is invisible.

• Avoid special characters (e.g. æ, å, ø, ö)

• Avoid reserved names: function, TRUE, mean, etc.

Consistency - style

Useful package for style

library(styler)
 
style_text("my_function<-function(my_data){
  my_data|> group_by(group)|> 
    summarise(mean=mean(variable),se=sd(variable)/sqrt(n()))}")  

my_function <- function(my_data) {
  my_data |>
    group_by(group) |>
    summarise(mean = mean(variable), se = sd(variable) / sqrt(n()))
}

Useful package for style

Consistency - standards

Use global data standards (ISO) when available for dates: yyyy-mm-dd